package org.jeecg.modules.lab.entrust.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.lab.entrust.entity.LabEntrustItems;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.jeecg.modules.lab.entrust.vo.LabSamplePage;
import org.jeecg.modules.lab.items.vo.LabEntrustItemPage;
import org.jeecg.modules.lab.utensil.entity.MonthList;
import org.springframework.stereotype.Repository;

/**
 * @Description: 实验项目表
 * @Author: jeecg-boot
 * @Date:   2023-08-10
 * @Version: V1.0
 */
@Repository
public interface LabEntrustItemsMapper extends BaseMapper<LabEntrustItems> {

    /**
     * 通过主表id查询子表数据
     *
     * @param mainId 主表id
     * @return List<LabEntrustItems>
     */
    public List<LabEntrustItems> selectItemsByMainId(@Param("mainId") String mainId);

    public List<LabEntrustItems> selectMaxDay(@Param("id")String id);

    List<MonthList> numMonth(@Param("year") String year);

    List<MonthList> timeMonth(@Param("year")String year);

    public List<LabEntrustItemPage> getEntrustItemList(@Param("kyId")String kyId);

    public List<LabEntrustItems> getItemsList(@Param("entrustId")String entrustId,@Param("userId")String userId);

    public void deleteByTaskId(@Param("taskId") String taskId);
}
